Go to the documentation of this file.
00001 using System;
00002 using System.Collections.Generic;
00003 using System.Linq;
00004 using System.Text;
00005 
00006 namespace FillCustomQueryTableCL
00007 {
00008     public class OtherQuery : PreselectionListQuery
00009     {
00010         private static string QueryTypeName = "Other";
00011         private static string GetParametersQuery =
00012             "SELECT " +
00013             "    1 FromMask, " +
00014             "    sys.parameters.name [Name], " +
00015             "    sys.parameters.parameter_id [Order], " +
00016             "    sys.types.name RelatedQuery, null RelatedTable " +
00017             "FROM sys.parameters  " +
00018             "    LEFT JOIN sys.objects on sys.parameters.object_id=sys.objects.object_id  " +
00019             "    LEFT JOIN sys.types ON sys.parameters.user_type_id=sys.types.user_type_id  " +
00020             "WHERE sys.objects.name='{0}' " +
00021             "ORDER BY FromMask, [Order] ";
00022 
00023         public OtherQuery(string name)
00024             : base(name, QueryTypeName, GetParametersQuery) { }
00025 
00026 
00027         protected override void PreСorrectParameters(System.Data.SqlClient.SqlDataReader reader)
00028         {
00029 
00030         }
00031         protected override void СorrectParameters()
00032         {
00033 
00034         }
00035     }
00036 }